* Table B6

use "temp/EIA_clean.dta", clear
gen dum = 1
bys year: egen numberfirms = total(dum) // number of firms
preserve
	collapse numberfirms, by(year)
	keep if year>=1994 & year<=1999
	gen temp1 = 0
	replace temp1 = 1 if year==1994
	foreach x of var numberfirms {
	gen `x'temp = `x' * temp1
	egen `x'94 = total(`x'temp)
	gen `x'_delta = (`x'-`x'94)*100
	drop `x'temp
	}
	gen numberfirms_growth = numberfirms_delta / numberfirms94
	drop if year==1994
	collapse numberfirms_growth 
	export excel "../../Output/TableB6_Data", first(varl) replace
restore
	
